[dbo].[MatchingGiftPlanRelationship]

SQLServer > iMIS1521GA > Tables > dbo.MatchingGiftPlanRelationship

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	0
Created	10:31:27 AM Tuesday, March 02, 2010
Last Modified	11:40:04 AM Monday, February 20, 2012

Columns

Name	Data Type	Max Length (Bytes)
MatchingGiftPlanRelationshipKey	uniqueidentifier	16
MatchingGiftPlanKey	uniqueidentifier	16
RelationshipTypeKey	uniqueidentifier	16
MarkedForDeleteOn	datetime	8

Indexes

	Name	Columns	Unique
	PK_MatchingGiftPlanRelationship	MatchingGiftPlanRelationshipKey

SQL Script

CREATE TABLE [dbo].[MatchingGiftPlanRelationship]
(
[MatchingGiftPlanRelationshipKey] [uniqueidentifier] NOT NULL,
[MatchingGiftPlanKey] [uniqueidentifier] NOT NULL,
[RelationshipTypeKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MatchingGiftPlanRelationship] ADD CONSTRAINT [PK_MatchingGiftPlanRelationship] PRIMARY KEY CLUSTERED ([MatchingGiftPlanRelationshipKey]) ON [PRIMARY]
GO

Uses